﻿CREATE TABLE ContentItems
(
	ContentItemID int NOT NULL PRIMARY KEY IDENTITY(1,1),
	Content nvarchar(MAX) NULL,
	Name nvarchar(256) NULL,
	PostTime datetime NOT NULL
)
GO

CREATE NONCLUSTERED INDEX IX_ContentItems_PostTime
ON ContentItems
(
	PostTime DESC
)
GO


CREATE TABLE [Images] (
	[ImageID] [int] NOT NULL PRIMARY KEY IDENTITY(1,1),
	[FileName] [nvarchar](256) NULL
)
GO
